SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE VIEW [dbo].[TCORDE_COMP]    
As    
SELECT [NU_ORCO], [CO_EMPR], [FE_CREA], [FE_EMIS], [FE_EXPI], [FE_ATEN], [FE_ENTR], [CO_MONE], [FA_CAMB],     
    [CO_MONE_BASE], [FA_CAMB_BASE], [CO_COMP], [NO_COMP], [NU_TLFN_COMP], [DE_MAIL_COMP], [CO_UNID], [CO_ALMA],    
    [CO_PROV], [CO_COND_PAGO], [CO_VIAS], [TI_TERM], [IM_BRUT_AFEC], [IM_BRUT_INAF], [IM_GAFO], [IM_FLET],     
    [IM_SEGU], [ST_AFEC_GAFO], [ST_AFEC_FLET], [ST_AFEC_SEGU], [ST_DCT1_BRAF], [ST_DCT1_BRIN], [ST_DCT1_GAFO],    
    [ST_DCT1_FLET], [ST_DCT1_SEGU], [ST_DCT2_BRAF], [ST_DCT2_BRIN], [ST_DCT2_GAFO], [ST_DCT2_FLET], [ST_DCT2_SEGU],     
    [PC_DCT1], [IM_DCT1], [PC_DCT2], [IM_DCT2], [CO_IMP1], [PC_IMP1], [IM_IMP1], [CO_IMP2], [PC_IMP2], [IM_IMP2],    
    [CO_IMP3], [PC_IMP3], [IM_IMP3], [DE_OBSE_0001], [DE_OBSE_0002], [ST_SERV], [ST_EXTR], [ST_ATEN], [ST_TESO],     
    [TI_AUXI_EMPR], [CO_AUXI_EMPR], [CO_ORDE_SERV], [TI_SITU], [NU_ORCO_ANTE], [TI_DIRE_PROV], [NU_ORCO_ORIG],     
    [ST_VALO_IMPO], [TI_FORM_PROR], [IM_PROR], [ST_ACTI_EXTR], [NU_DECL_ADUA], [DE_TIEM_ENTR], [DE_DIRE_ENTR],     
    [CO_USUA_APRO], [CO_USUA_CREA], [FE_USUA_CREA], [CO_USUA_MODI], [FE_USUA_MODI], [NO_CONT_PROV]     
FROM   [OFILOGI].[dbo].[TCORDE_COMP]
GO
